---
title: WorksheetFunction.Proper Method (Excel)
keywords: vbaxl10.chm137125
f1_keywords:
- vbaxl10.chm137125
ms.prod: excel
api_name:
- Excel.WorksheetFunction.Proper
ms.assetid: b90b6fbd-dab0-2ef3-77a8-e39f22b61414
ms.date: 06/08/2017
---


# WorksheetFunction.Proper Method (Excel)

Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.


## Syntax

 _expression_ . **Proper**( **_Arg1_** )

 _expression_ A variable that represents a **WorksheetFunction** object.


### Parameters



|**Name**|**Required/Optional**|**Data Type**|**Description**|
|:-----|:-----|:-----|:-----|
| _Arg1_|Required| **String**|Text - text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.|

### Return Value

String


## See also


#### Concepts


[WorksheetFunction Object](worksheetfunction-object-excel.md)

